﻿using System;
using System.Collections.Generic;
using System.ComponentModel.DataAnnotations;
using System.ComponentModel.DataAnnotations.Schema;
using System.Linq;
using System.Runtime.CompilerServices;
using System.Text;
using System.Threading.Tasks;

namespace EntityModel
{
    /// <summary>
    /// 学生人员信息表
    /// </summary>
    [Table("A2")]
    public class EM_Students:EntityBase
    {
        /// <summary>
        /// 学生姓名
        /// </summary>
        [Column("A001")]
        [Required]
        [StringLength(50)]
        public string? StudentName { get; set; }

        /// <summary>
        /// 性别
        /// </summary>
        [StringLength(30)]
        [Column("A002")]
        [Required]
        public bool Sex { get; set; }

        /// <summary>
        /// 年龄
        /// </summary>
        [Column("A003")]
        [Required]
        public int? Age { get; set; }

        /// <summary>
        /// 家庭地址
        /// </summary>
        [Column("A004")]
        [StringLength(50)]
        [Required]
        public string? HomeAddress { get; set; }

        /// <summary>
        /// 邮箱
        /// </summary>
        [StringLength(30)]
        [Column("A005")]
        [Required]
        public string? Email { get; set; }

        /// <summary>
        /// 系部
        /// </summary>
        [Required]
        [Column("A006")]
        [StringLength(50)]
        public string? Department { get; set; }

        /// <summary>
        /// 班级
        /// </summary>
        [Required]
        [Column("A007")]
        [StringLength(50)]
        public string? Class { get; set; }


        #region 王欣雨
        /// <summary>
        /// 缴费人员
        /// </summary>
        [Column("D001")]
        [Required]
        public ICollection<UserPayment>? UserPayment { get; set; }

        /// <summary>
        /// 社团报名人员信息
        /// </summary>
        [Column("D001")]
        [Required]
        public ICollection<Organizations>? Organizations { get; set; }

        /// <summary>
        /// 入住人员信息
        /// </summary>
        [Column("D001")]
        [Required]
        public ICollection<EM_Hostel>? EM_Hostel { get; set; }
        #endregion

        #region 陈亮
        /// <summary>
        /// 成绩
        /// </summary>
        [Column("C001")]
        [Required]
        public ICollection<EM_Score>? EM_Score { get; set; }

        /// <summary>
        /// 食堂
        /// </summary>
        [Column("C001")]
        [Required]
        public ICollection<EM_Canteen>? EM_Canteen { get; set; }

        /// <summary>
        /// 考勤
        /// </summary>
        [Column("C001")]
        [Required]
        public ICollection<EM_Attendance>? EM_Attendance { get; set; }
        #endregion
    }
}
